UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GgcpBAq5ejWEm9brLPmsJxJteaSPa70dh52e0nwdL3o='
WHERE
key_id = '78e2bc5c603d8b5bbe70f5eda5eb9a231868ffec24504882f64033a570dc81ac'
AND (
token = 'GgcpBAq5ejWEm9brLPmsJxJteaSPa70dh52e0nwdL3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)