UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X2k124lKBfRji3tq8hqwoUSKXglpK9z1Lop/Y6E0HkQ='
WHERE
key_id = '28c87c100c92c1a37cd3f68bf10c945b9ff93be905803d128062b0acb56c003b'
AND (
token = 'X2k124lKBfRji3tq8hqwoUSKXglpK9z1Lop/Y6E0HkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)