UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YAj0W4VBGaHvFQ3mE3pDulgqdImcEecjFV11Kgk/sew='
WHERE
key_id = '6f1264767906d378931ef51acd80e3076d84c423ab1f68fdf672560cf7c045d5'
AND (
token = 'YAj0W4VBGaHvFQ3mE3pDulgqdImcEecjFV11Kgk/sew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)