UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g4NKukOr4wiyA4r5ECya2m5hFuHjItqA2ns5FmhFxjo='
WHERE
key_id = '6adc3824befaf5af6c0a2ab59e4bbab91b2e750e03427229b3946a862350098a'
AND (
token = 'g4NKukOr4wiyA4r5ECya2m5hFuHjItqA2ns5FmhFxjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)