UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xyk7pBi7a/OgNkpKeRSSt2jtKE6OcBojzX1IVp5R3Ys='
WHERE
key_id = '267e578ef660f080fcb4e0c30d0b1ec07ef72b1efaf6bdaae4908897579bbb41'
AND (
token = 'xyk7pBi7a/OgNkpKeRSSt2jtKE6OcBojzX1IVp5R3Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)