UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vd4j0Fg6wth5cRJdEdo4x1k6t76Q8SLsCcRuod9WKx8='
WHERE
key_id = 'ce9b9c1d6e219ad25462b9893037977d8e0c4c122b27e740f9f5fb25b775ba3a'
AND (
token = 'vd4j0Fg6wth5cRJdEdo4x1k6t76Q8SLsCcRuod9WKx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)