UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9uCiCTLWRm/D0bnYU5YWt4m5v20kunYlTP/p+yCxug='
WHERE
key_id = '162c8d4d42f7ab2e0c691ec3a712f61aeb64b846a70c28424bfc041f686405ec'
AND (
token = 'L9uCiCTLWRm/D0bnYU5YWt4m5v20kunYlTP/p+yCxug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)