UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pBKPLVYf+efqEznWi02NlX1p3gDi9Fbjf8629u7ABtw='
WHERE
key_id = '946fa9c35a34e7661fafc08271307df199179458f4b8eabb5b6fccb784f28d52'
AND (
token = 'pBKPLVYf+efqEznWi02NlX1p3gDi9Fbjf8629u7ABtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)