UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuQlyGEVUoYss+zn0W9QWwCvN5pjV9qzCLj6/PKTDWM='
WHERE
key_id = '42016cb935b9888286d95d61b6642543f0aabebdd093b1aa58a03058c1f03348'
AND (
token = 'XuQlyGEVUoYss+zn0W9QWwCvN5pjV9qzCLj6/PKTDWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)