UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PzdJUIyjeEbAMvbSpCDMvRrqB+DDYC/9iMK5ObIGPsw='
WHERE
key_id = 'c76a4ef9dd69208ecbf536ec098158f64ded14af196e6c49bb4d15ddad317703'
AND (
token = 'PzdJUIyjeEbAMvbSpCDMvRrqB+DDYC/9iMK5ObIGPsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)