UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgFU5snfwe9w2Da/BLtSOSaY0yNUXT47VVqMX+5+uMI='
WHERE
key_id = '0cbaf1a6b1c4386e3ea8057d13e36a8ffb179e7869a03ffcb68bb2d165aa921f'
AND (
token = 'pgFU5snfwe9w2Da/BLtSOSaY0yNUXT47VVqMX+5+uMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)