UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ggSY1dEgJrDerGG3G6If4x6vqH7vLVMTBroEybYuFaQ='
WHERE
key_id = 'a05b5a1882ce68959b3a4efd0b458594b3e0c6489e39da332369768d4b5d02d4'
AND (
token = 'ggSY1dEgJrDerGG3G6If4x6vqH7vLVMTBroEybYuFaQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)