UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9foW1fpEfJjs2i+AxtHggDD06PfZ+QGWss9F516z9ec='
WHERE
key_id = '2d26495a5371e4d0c95b993a04b63e598a688d51e61b0c1d3a950dc46f8b2025'
AND (
token = '9foW1fpEfJjs2i+AxtHggDD06PfZ+QGWss9F516z9ec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)